Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	14576
Missing cells	40218
Missing cells (%)	18.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	120.0 B

Variable types

Categorical	6
Numeric	9

Alerts

`Name` has a high cardinality: 10327 distinct values	High cardinality
`Publisher` has a high cardinality: 552 distinct values	High cardinality
`Developer` has a high cardinality: 1577 distinct values	High cardinality
`NA_Sales` is highly correlated with `EU_Sales` and 1 other fields	High correlation
`EU_Sales` is highly correlated with `NA_Sales` and 1 other fields	High correlation
`Critic_Score` is highly correlated with `User_Score`	High correlation
`Critic_Count` is highly correlated with `User_Count`	High correlation
`User_Score` is highly correlated with `Critic_Score`	High correlation
`User_Count` is highly correlated with `Critic_Count`	High correlation
`Global_Sales` is highly correlated with `NA_Sales` and 1 other fields	High correlation
`NA_Sales` is highly correlated with `EU_Sales` and 1 other fields	High correlation
`EU_Sales` is highly correlated with `NA_Sales` and 1 other fields	High correlation
`JP_Sales` is highly correlated with `Global_Sales`	High correlation
`Global_Sales` is highly correlated with `NA_Sales` and 2 other fields	High correlation
`NA_Sales` is highly correlated with `EU_Sales` and 1 other fields	High correlation
`EU_Sales` is highly correlated with `NA_Sales` and 1 other fields	High correlation
`Global_Sales` is highly correlated with `NA_Sales` and 1 other fields	High correlation
`Platform` is highly correlated with `Year_of_Release`	High correlation
`Year_of_Release` is highly correlated with `Platform`	High correlation
`Genre` is highly correlated with `Rating`	High correlation
`NA_Sales` is highly correlated with `EU_Sales` and 2 other fields	High correlation
`EU_Sales` is highly correlated with `NA_Sales` and 2 other fields	High correlation
`JP_Sales` is highly correlated with `NA_Sales` and 2 other fields	High correlation
`Critic_Score` is highly correlated with `User_Score`	High correlation
`Critic_Count` is highly correlated with `User_Count`	High correlation
`User_Score` is highly correlated with `Critic_Score`	High correlation
`User_Count` is highly correlated with `Critic_Count`	High correlation
`Rating` is highly correlated with `Genre`	High correlation
`Global_Sales` is highly correlated with `NA_Sales` and 2 other fields	High correlation
`Year_of_Release` has 232 (1.6%) missing values	Missing
`Critic_Score` has 7359 (50.5%) missing values	Missing
`Critic_Count` has 7359 (50.5%) missing values	Missing
`User_Score` has 5816 (39.9%) missing values	Missing
`User_Count` has 7780 (53.4%) missing values	Missing
`Developer` has 5747 (39.4%) missing values	Missing
`Rating` has 5872 (40.3%) missing values	Missing
`Name` is uniformly distributed	Uniform
`NA_Sales` has 3861 (26.5%) zeros	Zeros
`EU_Sales` has 4864 (33.4%) zeros	Zeros
`JP_Sales` has 9019 (61.9%) zeros	Zeros
`User_Score` has 1965 (13.5%) zeros	Zeros

Reproduction

Analysis started	2022-04-25 04:08:00.647214
Analysis finished	2022-04-25 04:08:13.051212
Duration	12.4 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	10327
Distinct (%)	70.9%
Missing	2
Missing (%)	< 0.1%
Memory size	114.0 KiB

Need for Speed: Most Wanted	11
Madden NFL 07	9
LEGO Marvel Super Heroes	9
Ratatouille	9
FIFA 14	9
Other values (10322)	14527

Length

Max length	124
Median length	22
Mean length	23.81357211
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7952 ?
Unique (%)	54.6%

Sample

1st row	Wii Sports
2nd row	Super Mario Bros.
3rd row	Mario Kart Wii
4th row	Wii Sports Resort
5th row	Pokemon Red/Pokemon Blue

Common Values

Value	Count	Frequency (%)
Need for Speed: Most Wanted	11	0.1%
Madden NFL 07	9	0.1%
LEGO Marvel Super Heroes	9	0.1%
Ratatouille	9	0.1%
FIFA 14	9	0.1%
LEGO The Hobbit	8	0.1%
Monopoly	8	0.1%
FIFA 15	8	0.1%
Cars	8	0.1%
FIFA Soccer 13	8	0.1%
Other values (10317)	14487	99.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
the	2403	4.2%
of	1493	2.6%
2	1058	1.8%
no	656	1.1%
	649	1.1%
3	474	0.8%
world	359	0.6%
pro	273	0.5%
game	272	0.5%
ii	262	0.5%
Other values (8646)	49640	86.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Platform
Categorical

HIGH CORRELATION

Distinct	31
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	114.0 KiB

PS2	1935
DS	1783
PS3	1209
Wii	1138
X360	1135
Other values (26)	7376

Length

Max length	4
Median length	3
Mean length	2.781970362
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Wii
2nd row	NES
3rd row	Wii
4th row	Wii
5th row	GB

Common Values

Value	Count	Frequency (%)
PS2	1935	13.3%
DS	1783	12.2%
PS3	1209	8.3%
Wii	1138	7.8%
X360	1135	7.8%
PS	1058	7.3%
PSP	1049	7.2%
PC	874	6.0%
GBA	712	4.9%
XB	693	4.8%
Other values (21)	2990	20.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ps2	1935	13.3%
ds	1783	12.2%
ps3	1209	8.3%
wii	1138	7.8%
x360	1135	7.8%
ps	1058	7.3%
psp	1049	7.2%
pc	874	6.0%
gba	712	4.9%
xb	693	4.8%
Other values (21)	2990	20.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Year_of_Release
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	39
Distinct (%)	0.3%
Missing	232
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%
Mean	2006.437117

Minimum	1980
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	114.0 KiB

Quantile statistics

Minimum	1980
5-th percentile	1996
Q1	2003
median	2007
Q3	2010
95-th percentile	2015
Maximum	2020
Range	40
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	5.955664119
Coefficient of variation (CV)	0.002968278482
Kurtosis	1.879039188
Mean	2006.437117
Median Absolute Deviation (MAD)	4
Skewness	-1.009238323
Sum	28780334
Variance	35.4699351
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
2009	1248	8.6%
2008	1213	8.3%
2010	1092	7.5%
2007	1067	7.3%
2011	955	6.6%
2006	886	6.1%
2005	795	5.5%
2002	718	4.9%
2003	675	4.6%
2004	664	4.6%
Other values (29)	5031	34.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1980	9	0.1%
1981	45	0.3%
1982	36	0.2%
1983	17	0.1%
1984	14	0.1%
1985	14	0.1%
1986	21	0.1%
1987	14	0.1%
1988	15	0.1%
1989	17	0.1%

Value	Count	Frequency (%)
2020	1	< 0.1%
2017	3	< 0.1%
2016	435	3.0%
2015	536	3.7%
2014	498	3.4%
2013	474	3.3%
2012	591	4.1%
2011	955	6.6%
2010	1092	7.5%
2009	1248	8.6%

Genre
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	114.0 KiB

Action	2974
Sports	2078
Misc	1503
Role-Playing	1300
Shooter	1171
Other values (7)	5548

Length

Max length	12
Median length	6
Mean length	7.135583917
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Sports
2nd row	Platform
3rd row	Racing
4th row	Sports
5th row	Role-Playing

Common Values

Value	Count	Frequency (%)
Action	2974	20.4%
Sports	2078	14.3%
Misc	1503	10.3%
Role-Playing	1300	8.9%
Shooter	1171	8.0%
Adventure	1127	7.7%
Racing	1084	7.4%
Platform	786	5.4%
Simulation	753	5.2%
Fighting	728	5.0%
Other values (2)	1070	7.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
action	2974	20.4%
sports	2078	14.3%
misc	1503	10.3%
role-playing	1300	8.9%
shooter	1171	8.0%
adventure	1127	7.7%
racing	1084	7.4%
platform	786	5.4%
simulation	753	5.2%
fighting	728	5.0%
Other values (2)	1070	7.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Publisher
Categorical

HIGH CARDINALITY

Distinct	552
Distinct (%)	3.8%
Missing	49
Missing (%)	0.3%
Memory size	114.0 KiB

Electronic Arts	1267
Activision	881
Ubisoft	803
Namco Bandai Games	778
Konami Digital Entertainment	709
Other values (547)	10089

Length

Max length	38
Median length	11
Mean length	13.64438632
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	176 ?
Unique (%)	1.2%

Sample

1st row	Nintendo
2nd row	Nintendo
3rd row	Nintendo
4th row	Nintendo
5th row	Nintendo

Common Values

Value	Count	Frequency (%)
Electronic Arts	1267	8.7%
Activision	881	6.0%
Ubisoft	803	5.5%
Namco Bandai Games	778	5.3%
Konami Digital Entertainment	709	4.9%
Nintendo	673	4.6%
THQ	638	4.4%
Sony Computer Entertainment	628	4.3%
Sega	542	3.7%
Take-Two Interactive	377	2.6%
Other values (542)	7231	49.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
entertainment	2142	8.1%
games	1671	6.3%
interactive	1446	5.5%
arts	1270	4.8%
electronic	1269	4.8%
activision	904	3.4%
ubisoft	816	3.1%
digital	798	3.0%
namco	778	2.9%
bandai	778	2.9%
Other values (617)	14593	55.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

NA_Sales
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	402
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2955769759

Minimum	0
Maximum	41.36
Zeros	3861
Zeros (%)	26.5%
Negative	0
Negative (%)	0.0%
Memory size	114.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.1
Q3	0.28
95-th percentile	1.19
Maximum	41.36
Range	41.36
Interquartile range (IQR)	0.28

Descriptive statistics

Standard deviation	0.8664905241
Coefficient of variation (CV)	2.931522395
Kurtosis	575.1870412
Mean	0.2955769759
Median Absolute Deviation (MAD)	0.1
Skewness	17.71213844
Sum	4308.33
Variance	0.7508058283
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3861	26.5%
0.02	542	3.7%
0.01	508	3.5%
0.03	446	3.1%
0.04	376	2.6%
0.08	368	2.5%
0.09	348	2.4%
0.1	336	2.3%
0.05	329	2.3%
0.13	308	2.1%
Other values (392)	7154	49.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3861	26.5%
0.01	508	3.5%
0.02	542	3.7%
0.03	446	3.1%
0.04	376	2.6%
0.05	329	2.3%
0.06	173	1.2%
0.07	281	1.9%
0.08	368	2.5%
0.09	348	2.4%

Value	Count	Frequency (%)
41.36	1	< 0.1%
29.08	1	< 0.1%
26.93	1	< 0.1%
23.2	1	< 0.1%
15.68	1	< 0.1%
15.61	1	< 0.1%
15	1	< 0.1%
14.44	1	< 0.1%
13.96	1	< 0.1%
12.78	1	< 0.1%

EU_Sales
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	307
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1639571899

Minimum	0
Maximum	28.96
Zeros	4864
Zeros (%)	33.4%
Negative	0
Negative (%)	0.0%
Memory size	114.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.03
Q3	0.13
95-th percentile	0.69
Maximum	28.96
Range	28.96
Interquartile range (IQR)	0.13

Descriptive statistics

Standard deviation	0.5363536856
Coefficient of variation (CV)	3.271303235
Kurtosis	669.1637779
Mean	0.1639571899
Median Absolute Deviation (MAD)	0.03
Skewness	17.76300594
Sum	2389.84
Variance	0.2876752761
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4864	33.4%
0.01	1275	8.7%
0.02	990	6.8%
0.03	648	4.4%
0.04	638	4.4%
0.05	430	3.0%
0.06	362	2.5%
0.07	326	2.2%
0.08	299	2.1%
0.09	263	1.8%
Other values (297)	4481	30.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4864	33.4%
0.01	1275	8.7%
0.02	990	6.8%
0.03	648	4.4%
0.04	638	4.4%
0.05	430	3.0%
0.06	362	2.5%
0.07	326	2.2%
0.08	299	2.1%
0.09	263	1.8%

Value	Count	Frequency (%)
28.96	1	< 0.1%
12.76	1	< 0.1%
10.95	1	< 0.1%
10.93	1	< 0.1%
9.2	1	< 0.1%
9.18	1	< 0.1%
9.14	1	< 0.1%
9.09	1	< 0.1%
8.89	1	< 0.1%
8.49	1	< 0.1%

JP_Sales
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	244
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0856586169

Minimum	0
Maximum	10.22
Zeros	9019
Zeros (%)	61.9%
Negative	0
Negative (%)	0.0%
Memory size	114.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.03
95-th percentile	0.41
Maximum	10.22
Range	10.22
Interquartile range (IQR)	0.03

Descriptive statistics

Standard deviation	0.3296458183
Coefficient of variation (CV)	3.848367277
Kurtosis	170.2991701
Mean	0.0856586169
Median Absolute Deviation (MAD)	0
Skewness	10.49877206
Sum	1248.56
Variance	0.1086663655
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9019	61.9%
0.02	722	5.0%
0.01	684	4.7%
0.03	523	3.6%
0.04	380	2.6%
0.05	304	2.1%
0.06	176	1.2%
0.1	153	1.0%
0.09	140	1.0%
0.11	138	0.9%
Other values (234)	2337	16.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9019	61.9%
0.01	684	4.7%
0.02	722	5.0%
0.03	523	3.6%
0.04	380	2.6%
0.05	304	2.1%
0.06	176	1.2%
0.07	86	0.6%
0.08	93	0.6%
0.09	140	1.0%

Value	Count	Frequency (%)
10.22	1	< 0.1%
7.2	1	< 0.1%
6.81	1	< 0.1%
6.5	1	< 0.1%
6.04	1	< 0.1%
5.65	1	< 0.1%
5.38	1	< 0.1%
5.33	1	< 0.1%
5.32	1	< 0.1%
4.87	1	< 0.1%

Critic_Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	80
Distinct (%)	1.1%
Missing	7359
Missing (%)	50.5%
Infinite	0
Infinite (%)	0.0%
Mean	69.67604268

Minimum	13
Maximum	98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	114.0 KiB

Quantile statistics

Minimum	13
5-th percentile	44
Q1	61
median	71
Q3	80
95-th percentile	89
Maximum	98
Range	85
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	13.77339065
Coefficient of variation (CV)	0.1976775677
Kurtosis	0.1621482683
Mean	69.67604268
Median Absolute Deviation (MAD)	9
Skewness	-0.6276894676
Sum	502852
Variance	189.7062899
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
71	235	1.6%
76	221	1.5%
70	220	1.5%
75	217	1.5%
78	216	1.5%
80	215	1.5%
73	212	1.5%
77	212	1.5%
81	211	1.4%
74	204	1.4%
Other values (70)	5054	34.7%
(Missing)	7359	50.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
13	1	< 0.1%
17	1	< 0.1%
19	5	< 0.1%
20	1	< 0.1%
23	3	< 0.1%
24	2	< 0.1%
25	6	< 0.1%
26	11	0.1%
27	6	< 0.1%
28	7	< 0.1%

Value	Count	Frequency (%)
98	4	< 0.1%
97	11	0.1%
96	18	0.1%
95	16	0.1%
94	37	0.3%
93	47	0.3%
92	53	0.4%
91	67	0.5%
90	73	0.5%
89	100	0.7%

Critic_Count
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	106
Distinct (%)	1.5%
Missing	7359
Missing (%)	50.5%
Infinite	0
Infinite (%)	0.0%
Mean	27.31204101

Minimum	3
Maximum	113
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	114.0 KiB

Quantile statistics

Minimum	3
5-th percentile	5
Q1	12
median	22
Q3	38
95-th percentile	67
Maximum	113
Range	110
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	19.46419649
Coefficient of variation (CV)	0.7126599027
Kurtosis	0.8069792626
Mean	27.31204101
Median Absolute Deviation (MAD)	12
Skewness	1.091984852
Sum	197111
Variance	378.8549451
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	259	1.8%
5	222	1.5%
9	214	1.5%
11	213	1.5%
7	207	1.4%
8	203	1.4%
17	203	1.4%
6	200	1.4%
16	197	1.4%
13	194	1.3%
Other values (96)	5105	35.0%
(Missing)	7359	50.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	1	< 0.1%
4	259	1.8%
5	222	1.5%
6	200	1.4%
7	207	1.4%
8	203	1.4%
9	214	1.5%
10	184	1.3%
11	213	1.5%
12	188	1.3%

Value	Count	Frequency (%)
113	1	< 0.1%
107	1	< 0.1%
106	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
103	1	< 0.1%
102	1	< 0.1%
101	2	< 0.1%
100	3	< 0.1%
99	1	< 0.1%

User_Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	95
Distinct (%)	1.1%
Missing	5816
Missing (%)	39.9%
Infinite	0
Infinite (%)	0.0%
Mean	5.549006849

Minimum	0
Maximum	9.7
Zeros	1965
Zeros (%)	13.5%
Negative	0
Negative (%)	0.0%
Memory size	114.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3.6
median	7
Q3	8
95-th percentile	8.8
Maximum	9.7
Range	9.7
Interquartile range (IQR)	4.4

Descriptive statistics

Standard deviation	3.25543152
Coefficient of variation (CV)	0.58666922
Kurtosis	-0.850241188
Mean	5.549006849
Median Absolute Deviation (MAD)	1.3
Skewness	-0.8719537997
Sum	48609.3
Variance	10.59783438
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1965	13.5%
7.8	284	1.9%
8.2	254	1.7%
8	252	1.7%
8.5	235	1.6%
8.3	232	1.6%
7.5	230	1.6%
7.9	229	1.6%
8.1	224	1.5%
7.3	213	1.5%
Other values (85)	4642	31.8%
(Missing)	5816	39.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1965	13.5%
0.2	1	< 0.1%
0.3	2	< 0.1%
0.5	2	< 0.1%
0.6	2	< 0.1%
0.7	2	< 0.1%
0.9	1	< 0.1%
1	2	< 0.1%
1.1	2	< 0.1%
1.2	3	< 0.1%

Value	Count	Frequency (%)
9.7	1	< 0.1%
9.6	2	< 0.1%
9.5	6	< 0.1%
9.4	10	0.1%
9.3	28	0.2%
9.2	38	0.3%
9.1	85	0.6%
9	109	0.7%
8.9	142	1.0%
8.8	167	1.1%

User_Count
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	868
Distinct (%)	12.8%
Missing	7780
Missing (%)	53.4%
Infinite	0
Infinite (%)	0.0%
Mean	172.5130959

Minimum	4
Maximum	10665
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	114.0 KiB

Quantile statistics

Minimum	4
5-th percentile	5
Q1	11
median	27
Q3	89
95-th percentile	779.5
Maximum	10665
Range	10661
Interquartile range (IQR)	78

Descriptive statistics

Standard deviation	576.6097163
Coefficient of variation (CV)	3.342411271
Kurtosis	100.4416536
Mean	172.5130959
Median Absolute Deviation (MAD)	20
Skewness	8.534899458
Sum	1172399
Variance	332478.7649
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	285	2.0%
6	281	1.9%
5	266	1.8%
8	244	1.7%
7	223	1.5%
9	209	1.4%
10	157	1.1%
11	145	1.0%
13	138	0.9%
12	136	0.9%
Other values (858)	4712	32.3%
(Missing)	7780	53.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	285	2.0%
5	266	1.8%
6	281	1.9%
7	223	1.5%
8	244	1.7%
9	209	1.4%
10	157	1.1%
11	145	1.0%
12	136	0.9%
13	138	0.9%

Value	Count	Frequency (%)
10665	1	< 0.1%
10179	1	< 0.1%
9629	1	< 0.1%
9073	1	< 0.1%
8713	1	< 0.1%
8665	1	< 0.1%
8003	1	< 0.1%
7512	1	< 0.1%
7322	1	< 0.1%
7064	1	< 0.1%

Developer
Categorical

HIGH CARDINALITY
MISSING

Distinct	1577
Distinct (%)	17.9%
Missing	5747
Missing (%)	39.4%
Memory size	114.0 KiB

Ubisoft	171
EA Sports	167
EA Canada	158
Konami	137
Capcom	123
Other values (1572)	8073

Length

Max length	80
Median length	13
Mean length	13.40593499
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	615 ?
Unique (%)	7.0%

Sample

1st row	Nintendo
2nd row	Nintendo
3rd row	Nintendo
4th row	Nintendo
5th row	Nintendo

Common Values

Value	Count	Frequency (%)
Ubisoft	171	1.2%
EA Sports	167	1.1%
EA Canada	158	1.1%
Konami	137	0.9%
Capcom	123	0.8%
EA Tiburon	102	0.7%
Ubisoft Montreal	94	0.6%
Electronic Arts	94	0.6%
Visual Concepts	89	0.6%
Traveller's Tales	75	0.5%
Other values (1567)	7619	52.3%
(Missing)	5747	39.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
games	936	5.4%
studios	691	4.0%
ea	608	3.5%
entertainment	561	3.2%
software	436	2.5%
ubisoft	404	2.3%
interactive	297	1.7%
sports	230	1.3%
canada	168	1.0%
inc	161	0.9%
Other values (1545)	12878	74.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Rating
Categorical

HIGH CORRELATION
MISSING

Distinct	8
Distinct (%)	0.1%
Missing	5872
Missing (%)	40.3%
Memory size	114.0 KiB

E	3460
T	2580
M	1410
E10+	1240
EC	7
Other values (3)	7

Length

Max length	4
Median length	1
Mean length	1.429342831
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	E
2nd row	E
3rd row	E
4th row	E
5th row	E

Common Values

Value	Count	Frequency (%)
E	3460	23.7%
T	2580	17.7%
M	1410	9.7%
E10+	1240	8.5%
EC	7	< 0.1%
RP	3	< 0.1%
K-A	3	< 0.1%
AO	1	< 0.1%
(Missing)	5872	40.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
e	3460	39.8%
t	2580	29.6%
m	1410	16.2%
e10	1240	14.2%
ec	7	0.1%
k-a	3	< 0.1%
rp	3	< 0.1%
ao	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Global_Sales
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	626
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5989715971

Minimum	0.01
Maximum	82.53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	114.0 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.02
Q1	0.05
median	0.22
Q3	0.55
95-th percentile	2.22
Maximum	82.53
Range	82.52
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	1.647698962
Coefficient of variation (CV)	2.750879958
Kurtosis	536.8290458
Mean	0.5989715971
Median Absolute Deviation (MAD)	0.19
Skewness	16.41123507
Sum	8730.61
Variance	2.714911869
Monotonicity	Decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	1087	7.5%
0.03	852	5.8%
0.04	651	4.5%
0.01	638	4.4%
0.05	631	4.3%
0.1	415	2.8%
0.11	397	2.7%
0.09	349	2.4%
0.14	324	2.2%
0.15	283	1.9%
Other values (616)	8949	61.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01	638	4.4%
0.02	1087	7.5%
0.03	852	5.8%
0.04	651	4.5%
0.05	631	4.3%
0.06	216	1.5%
0.09	349	2.4%
0.1	415	2.8%
0.11	397	2.7%
0.13	31	0.2%

Value	Count	Frequency (%)
82.53	1	< 0.1%
40.24	1	< 0.1%
35.52	1	< 0.1%
32.77	1	< 0.1%
31.37	1	< 0.1%
30.26	1	< 0.1%
29.8	1	< 0.1%
28.92	1	< 0.1%
28.32	1	< 0.1%
28.31	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Name	Platform	Year_of_Release	Genre	Publisher	NA_Sales	EU_Sales	JP_Sales	Critic_Score	Critic_Count	User_Score	User_Count	Developer	Rating	Global_Sales
0	Wii Sports	Wii	2006.0	Sports	Nintendo	41.36	28.96	3.77	76.0	51.0	8.0	322.0	Nintendo	E	82.53
1	Super Mario Bros.	NES	1985.0	Platform	Nintendo	29.08	3.58	6.81	NaN	NaN	NaN	NaN	NaN	NaN	40.24
2	Mario Kart Wii	Wii	2008.0	Racing	Nintendo	15.68	12.76	3.79	82.0	73.0	8.3	709.0	Nintendo	E	35.52
3	Wii Sports Resort	Wii	2009.0	Sports	Nintendo	15.61	10.93	3.28	80.0	73.0	8.0	192.0	Nintendo	E	32.77
4	Pokemon Red/Pokemon Blue	GB	1996.0	Role-Playing	Nintendo	11.27	8.89	10.22	NaN	NaN	NaN	NaN	NaN	NaN	31.37
5	Tetris	GB	1989.0	Puzzle	Nintendo	23.20	2.26	4.22	NaN	NaN	NaN	NaN	NaN	NaN	30.26
6	New Super Mario Bros.	DS	2006.0	Platform	Nintendo	11.28	9.14	6.50	89.0	65.0	8.5	431.0	Nintendo	E	29.80
7	Wii Play	Wii	2006.0	Misc	Nintendo	13.96	9.18	2.93	58.0	41.0	6.6	129.0	Nintendo	E	28.92
8	New Super Mario Bros. Wii	Wii	2009.0	Platform	Nintendo	14.44	6.94	4.70	87.0	80.0	8.4	594.0	Nintendo	E	28.32
9	Duck Hunt	NES	1984.0	Shooter	Nintendo	26.93	0.63	0.28	NaN	NaN	NaN	NaN	NaN	NaN	28.31

Last rows

	Name	Platform	Year_of_Release	Genre	Publisher	NA_Sales	EU_Sales	JP_Sales	Critic_Score	Critic_Count	User_Score	User_Count	Developer	Rating	Global_Sales
14566	15 Days	PC	2009.0	Adventure	DTP Entertainment	0.00	0.01	0.00	63.0	6.0	5.8	8.0	DTP Entertainment	NaN	0.01
14567	Men in Black II: Alien Escape	GC	2003.0	Shooter	Infogrames	0.01	0.00	0.00	NaN	NaN	0.0	NaN	Atari	T	0.01
14568	Aiyoku no Eustia	PSV	2014.0	Misc	dramatic create	0.00	0.00	0.01	NaN	NaN	NaN	NaN	NaN	NaN	0.01
14569	Woody Woodpecker in Crazy Castle 5	GBA	2002.0	Platform	Kemco	0.01	0.00	0.00	NaN	NaN	NaN	NaN	NaN	NaN	0.01
14570	SCORE International Baja 1000: The Official Game	PS2	2008.0	Racing	Activision	0.00	0.00	0.00	NaN	NaN	NaN	NaN	NaN	NaN	0.01
14571	Samurai Warriors: Sanada Maru	PS3	2016.0	Action	Tecmo Koei	0.00	0.00	0.01	NaN	NaN	NaN	NaN	NaN	NaN	0.01
14572	LMA Manager 2007	X360	2006.0	Sports	Codemasters	0.00	0.01	0.00	NaN	NaN	NaN	NaN	NaN	NaN	0.01
14573	Haitaka no Psychedelica	PSV	2016.0	Adventure	Idea Factory	0.00	0.00	0.01	NaN	NaN	NaN	NaN	NaN	NaN	0.01
14574	Spirits & Spells	GBA	2003.0	Platform	Wanadoo	0.01	0.00	0.00	NaN	NaN	NaN	NaN	NaN	NaN	0.01
14575	Winning Post 8 2016	PSV	2016.0	Simulation	Tecmo Koei	0.00	0.00	0.01	NaN	NaN	NaN	NaN	NaN	NaN	0.01

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows